﻿CREATE TABLE DBBackOffice.DBInventory (
	ID								uniqueidentifier PRIMARY KEY,				/* Unique GUID for this inventory */
	DBBackOfficeID					uniqueidentifier NOT NULL,					/* is inside this back office */
	DBExecutionContextINodeID		uniqueidentifier NOT NULL,					/* attached under this ExecutionContextINode */
	Date							datetime2 NOT NULL,							/* inventory is for thid date */		
	
	FOREIGN KEY (DBBackOfficeID) REFERENCES DBBackOffice.DBBackOffice(ID) ON DELETE CASCADE,	
);